C_Schagmtdelivaddress

Scheduling Agreement Delivery Address C View | view: CSCHAGRADDRESSWD | TRAN | Extraction: Not supported | Component: Contract
Tables used: EKKOEKPOADCPADRCADR6ADR2KNA1T001WLFA1
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AddressType null
DeliveryAddressID Manual address number in purchasing document item AD_ADDRNUM
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
StreetName Street TEXT60
HouseNumber House Number TEXT10
PostalCode City postal code CHAR10
CityName City TEXT40
MobileNumber Telephone no.: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_SCHAGMTDELIVADDRESS.MANDT == T005.MANDT
  • C_SCHAGMTDELIVADDRESS.COUNTRY == T005.LAND1
Customer
  • Client
  • Customer
  • C_SCHAGMTDELIVADDRESS.MANDT == KNA1.MANDT
  • C_SCHAGMTDELIVADDRESS.CUSTOMER == KNA1.KUNNR
Number of delivery address
  • Client
  • ?
  • ?
  • Number of delivery address
  • C_SCHAGMTDELIVADDRESS.MANDT == ADRC.CLIENT
  • C_SCHAGMTDELIVADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • C_SCHAGMTDELIVADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_SCHAGMTDELIVADDRESS.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_SCHAGMTDELIVADDRESS.MANDT == T005S.MANDT
  • C_SCHAGMTDELIVADDRESS.COUNTRY == T005S.LAND1
  • C_SCHAGMTDELIVADDRESS.REGION == T005S.BLAND