I_Schedgagrmtdeliveryaddress

Scheduling Agreement Delivery Address Basic View | view: ISCHAGMTDELADDR | 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
DeliveryAddressID Manual address number in purchasing document item AD_ADDRNUM
AddressType null
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address)
StreetName Street
HouseNumber House Number
PostalCode City postal code
CityName City
MobileNumber Telephone no.: dialling code+number
EmailAddress E-Mail Address
PhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
Master Data Relations Join Conditions
Language key I_SCHEDGAGRMTDELIVERYADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_SCHEDGAGRMTDELIVERYADDRESS.MANDT == T005.MANDT
  • I_SCHEDGAGRMTDELIVERYADDRESS.COUNTRY == T005.LAND1
Customer
  • Client
  • Customer
  • I_SCHEDGAGRMTDELIVERYADDRESS.MANDT == KNA1.MANDT
  • I_SCHEDGAGRMTDELIVERYADDRESS.CUSTOMER == KNA1.KUNNR
Plant
  • Client
  • Plant
  • I_SCHEDGAGRMTDELIVERYADDRESS.MANDT == T001W.MANDT
  • I_SCHEDGAGRMTDELIVERYADDRESS.PLANT == T001W.WERKS
Number of delivery address
  • ?
  • ?
  • Client
  • Number of delivery address
  • I_SCHEDGAGRMTDELIVERYADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_SCHEDGAGRMTDELIVERYADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_SCHEDGAGRMTDELIVERYADDRESS.MANDT == ADRC.CLIENT
  • I_SCHEDGAGRMTDELIVERYADDRESS.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_SCHEDGAGRMTDELIVERYADDRESS.REGION == T005S.BLAND
  • I_SCHEDGAGRMTDELIVERYADDRESS.MANDT == T005S.MANDT
  • I_SCHEDGAGRMTDELIVERYADDRESS.COUNTRY == T005S.LAND1