I_PURCTRADDRESSWD

CDS View
49 Fields 1 CDS Views

Contract Address Info with Draft

I_PURCTRADDRESSWD is a CDS View in S/4HANA. Contract Address Info with Draft. It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PurCtrItemAddress view from CONSUMPTION Contract Item Address Information

Fields (49)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 1
KEY PurchaseContractItem PurchaseContractItem 1
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
AddressID AddressID 1
AddressIDForEdit AddressIDForEdit 1
AddressTimeZone AddressTimeZone 1
Building Building 1
CareOfName CareOfName 1
CityCode CityCode 1
CityName CityName 1
CompanyPostalCode CompanyPostalCode 1
ConsigneeName3 ConsigneeName3 1
ConsigneeName4 ConsigneeName4 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
County County 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
District District 1
EmailAddress EmailAddress 1
FaxNumber FaxNumber 1
Floor Floor 1
FormOfAddress FormOfAddress 1
FullName FullName 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
MobilePhoneNumber MobilePhoneNumber 1
PhoneNumber PhoneNumber 1
Plant Plant 1
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
PurchaseContractForEdit PurchaseContractForEdit 1
PurchaseContractItemForEdit PurchaseContractItemForEdit 1
Region Region 1
RoomNumber RoomNumber 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSuffixName StreetSuffixName 1
TaxJurisdiction TaxJurisdiction 1
TransportZone TransportZone 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Contract Address Info with Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCTRADDRESSWD (
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSID,
    ADDRESSIDFOREDIT,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYCODE,
    CITYNAME,
    COMPANYPOSTALCODE,
    CONSIGNEENAME3,
    CONSIGNEENAME4,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    EMAILADDRESS,
    FAXNUMBER,
    FLOOR,
    FORMOFADDRESS,
    FULLNAME,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    MOBILEPHONENUMBER,
    PHONENUMBER,
    PLANT,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    PURCHASECONTRACTFOREDIT,
    PURCHASECONTRACTITEMFOREDIT,
    REGION,
    ROOMNUMBER,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TRANSPORTZONE,
    PRIMARY KEY (PURCHASECONTRACT, PURCHASECONTRACTITEM)
);

Learn More